package cn.stylefeng.guns.modular.hx.storage.mapper;

import cn.stylefeng.guns.modular.bi.entity.vo.DpkcQueryIby;
import cn.stylefeng.guns.modular.hx.storage.entity.HxStorageStock;
import cn.stylefeng.guns.modular.hx.storage.model.params.HxStorageStockParam;
import cn.stylefeng.guns.modular.hx.storage.model.result.HxStorageStockResult;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import org.apache.ibatis.annotations.Param;
import java.util.List;
import java.util.Map;

/**
 * <p>
 * 库存表 Mapper 接口
 * </p>
 *
 * @author zhucx
 * @since 2023-08-15
 */
public interface HxStorageStockMapper extends BaseMapper<HxStorageStock> {

    List<HxStorageStockResult> list(@Param("paramCondition") HxStorageStockParam hxStorageStockParam);
    /**
     * 获取列表
     *
     * @author zhucx
     * @Date 2023-08-15
     */
    List<HxStorageStockResult> customList(@Param("paramCondition") HxStorageStockParam paramCondition);

    /**
     * 获取map列表
     *
     * @author zhucx
     * @Date 2023-08-15
     */
    List<Map<String, Object>> customMapList(@Param("paramCondition") HxStorageStockParam paramCondition);

    /**
     * 获取分页实体列表
     *
     * @author zhucx
     * @Date 2023-08-15
     */
    IPage<HxStorageStockParam> customPageList(@Param("page") Page page, @Param("paramCondition") HxStorageStockParam paramCondition, @Param("condition") String condition);
    IPage<HxStorageStockParam> customPageList1(@Param("page") Page page, @Param("paramCondition") HxStorageStockParam paramCondition, @Param("condition") String condition);
    IPage<HxStorageStockParam> customPageList2(@Param("page") Page page, @Param("paramCondition") HxStorageStockParam paramCondition, @Param("condition") String condition);

    List<HxStorageStockParam> List2(@Param("paramCondition") HxStorageStockParam paramCondition,@Param("condition") String condition);
    /**
     * 获取分页map列表
     *
     * @author zhucx
     * @Date 2023-08-15
     */
    Page<Map<String, Object>> customPageMapList(@Param("page") Page page, @Param("paramCondition") HxStorageStockParam paramCondition);

    HxStorageStockResult findBySpec(@Param("paramCondition") HxStorageStockParam paramCondition, @Param("operateId")Long operateId);

    List<HxStorageStockResult> findGoodsListBySpec(@Param("paramCondition")HxStorageStockParam paramCondition, @Param("deptId") Long deptId, @Param("operateId") Long operateId);

    List<HxStorageStockResult> findKcListBySpec(@Param("paramCondition")HxStorageStockParam paramCondition, @Param("deptId") Long deptId, @Param("operateId") Long operateId);

    List<HxStorageStockResult> hxStorageMoveList(@Param("paramCondition") HxStorageStockParam paramCondition,@Param("condition") String condition,@Param("deptId") Long deptId,@Param("operateId") Long operateId);

    List<HxStorageStockResult> hxStorageoffShelfList(@Param("paramCondition") HxStorageStockParam paramCondition,@Param("condition") String condition,@Param("deptId") Long deptId,@Param("operateId") Long operateId);

	List<HxStorageStockResult> findsubListBySpec(@Param("paramCondition")HxStorageStockParam subHxStorageStockParam);

    List<HxStorageStockResult> findListByStorageNumber(@Param("paramCondition")HxStorageStockParam hxStorageStockParam);

    List<HxStorageStockResult> findListByStorageNumber1(@Param("paramCondition")HxStorageStockParam hxStorageStockParam);

    HxStorageStockResult sumPositionStock(@Param("paramCondition")HxStorageStockParam sumHxStorageStockParam);

	HxStorageStockResult findaddOffShelf(@Param("paramCondition")HxStorageStockParam offShelfparam);
	
    Page<HxStorageStockResult> findchoicePageBySpec(@Param("page") Page page, @Param("paramCondition") HxStorageStockParam paramCondition, @Param("condition") String condition);

    Page<HxStorageStockResult> findchoicePageBySpec2(@Param("page") Page page, @Param("paramCondition") HxStorageStockParam paramCondition, @Param("condition") String condition);

    List<HxStorageStockResult> findCccapacityData(@Param("paramCondition")HxStorageStockResult hxStorageStockResult);
    
	List<HxStorageStockParam> findlistAllBySpec(@Param("paramCondition")HxStorageStockParam hxStorageStockParam, @Param("condition")String condition);
	
	List<HxStorageStockResult> findListBySpec(@Param("paramCondition")HxStorageStockParam param);

    List<HxStorageStockResult> getPositionKcnum(@Param("paramCondition")HxStorageStockParam param);

	void deleteBySpec(@Param("paramCondition")HxStorageStockParam stockParamdelete);
	
    List<HxStorageStockResult> findaddOffShelflist(@Param("paramCondition")HxStorageStockParam offShelfparam);
    
	List<HxStorageStockParam> findlistAllBySpec2(@Param("paramCondition")HxStorageStockParam hxStorageStockParam, @Param("condition")String condition);
    
	List<HxStorageStockParam> findlistAllBySpec3(@Param("paramCondition")HxStorageStockParam hxStorageStockParam, @Param("condition")String condition);

    List<HxStorageStockParam> findlistAllBySpecPd(@Param("paramCondition")HxStorageStockParam hxStorageStockParam, @Param("condition")String condition);

    Page<HxStorageStockResult> dpkcQuery(@Param("page") Page page,@Param("paramCondition") DpkcQueryIby dpkcQueryIby);


    List<HxStorageStockResult> dpkcQueryAll(@Param("paramCondition") DpkcQueryIby dpkcQueryIby);

}
